CF_FixWidth2Query Example
Column list:
(Comma delimited list of column names. For example: ID,)
Column width:
(Comma delimited list of column width. For example: 3,2,1,4)
Start row:
End row:
(Put 0 to process all rows)
Fix width string:
ALFKIAlfreds Futterkiste Maria Anders Sales Representative Obere Str. 57 Berlin 12209 Germany 030-0074321 030-0076545 ANATRAna Trujillo Emparedados y helados Ana Trujillo Owner Avda. de la Constituci�n 2222 M�xico D.F. 05021 Mexico (5) 555-4729 (5) 555-3745 ANTONAntonio Moreno Taquer�a Antonio Moreno Owner Mataderos 2312 M�xico D.F. 05023 Mexico (5) 555-3932 AROUTAround the Horn Thomas Hardy Sales Representative 120 Hanover Sq. London WA1 1DP UK (171) 555-7788 (171) 555-6750 BERGSBerglunds snabbk�p Christina Berglund Order Administrator Berguvsv�gen 8 Lule� S-958 22 Sweden 0921-12 34 65 0921-12 34 67 BLAUSBlauer See Delikatessen Hanna Moos Sales Representative Forsterstr. 57 Mannheim 68306 Germany 0621-08460 0621-08924 BLONPBlondesddsl p�re et fils Fr�d�rique Citeaux Marketing Manager 24, place Kl�ber Strasbourg 67000 France 88.60.15.31 88.60.15.32 BOLIDB�lido Comidas preparadas Mart�n Sommer Owner C/ Araquil, 67 Madrid 28023 Spain (91) 555 22 82 (91) 555 91 99 BONAPBon app' Laurence Lebihan Owner 12, rue des Bouchers Marseille 13008 France 91.24.45.40 91.24.45.41 BOTTMBottom-Dollar Markets Elizabeth Lincoln Accounting Manager 23 Tsawassen Blvd. Tsawassen BC T2F 8M4 Canada (604) 555-4729 (604) 555-3745 BSBEVB's Beverages Victoria Ashworth Sales Representative Fauntleroy Circus London EC2 5NT UK (171) 555-1212 CACTUCactus Comidas para llevar Patricio Simpson Sales Agent Cerrito 333 Buenos Aires 1010 Argentina (1) 135-5555 (1) 135-4892 CENTCCentro comercial Moctezuma Francisco Chang Marketing Manager Sierras de Granada 9993 M�xico D.F. 05022 Mexico (5) 555-3392 (5) 555-7293 CHOPSChop-suey Chinese Yang Wang Owner Hauptstr. 29 Bern 3012 Switzerland 0452-076545 COMMICom�rcio Mineiro Pedro Afonso Sales Associate Av. dos Lus�adas, 23 Sao Paulo SP 05432-043 Brazil (11) 555-7647 CONSHConsolidated Holdings Elizabeth Brown Sales Representative Berkeley Gardens 12 Brewery London WX1 6LT UK (171) 555-2282 (171) 555-9199 DRACDDrachenblut Delikatessen Sven Ottlieb Order Administrator Walserweg 21 Aachen 52066 Germany 0241-039123 0241-059428 DUMONDu monde entier Janine Labrune Owner 67, rue des Cinquante Otages Nantes 44000 France 40.67.88.88 40.67.89.89 EASTCEastern Connection Ann Devon Sales Agent 35 King George London WX3 6FW UK (171) 555-0297 (171) 555-3373 ERNSHErnst Handel Roland Mendel Sales Manager Kirchgasse 6 Graz 8010 Austria 7675-3425 7675-3426 FAMIAFamilia Arquibaldo Aria Cruz Marketing Assistant Rua Or�s, 92 Sao Paulo SP 05442-030 Brazil (11) 555-9857 FISSAFISSA Fabrica Inter. Salchichas S.A. Diego Roel Accounting Manager C/ Moralzarzal, 86 Madrid 28034 Spain (91) 555 94 44 (91) 555 55 93 FOLIGFolies gourmandes Martine Ranc� Assistant Sales Agent 184, chauss�e de Tournai Lille 59000 France 20.16.10.16 20.16.10.17 FOLKOFolk och f� HB Maria Larsson Owner �kergatan 24 Br�cke S-844 67 Sweden 0695-34 67 21 FRANKFrankenversand Peter Franken Marketing Manager Berliner Platz 43 M�nchen 80805 Germany 089-0877310 089-0877451 FRANRFrance restauration Carine Schmitt Marketing Manager 54, rue Royale Nantes 44000 France 40.32.21.21 40.32.21.20 FRANSFranchi S.p.A. Paolo Accorti Sales Representative Via Monte Bianco 34 Torino 10100 Italy 011-4988260 011-4988261 FURIBFuria Bacalhau e Frutos do Mar Lino Rodriguez Sales Manager Jardim das rosas n. 32 Lisboa 1675 Portugal (1) 354-2534 (1) 354-2535 GALEDGaler�a del gastr�nomo Eduardo Saavedra Marketing Manager Rambla de Catalu�a, 23 Barcelona 08022 Spain (93) 203 4560 (93) 203 4561 GODOSGodos Cocina T�pica Jos� Pedro Freyre Sales Manager C/ Romero, 33 Sevilla 41101 Spain (95) 555 82 82 GOURLGourmet Lanchonetes Andr� Fonseca Sales Associate Av. Brasil, 442 Campinas SP 04876-786 Brazil (11) 555-9482 GREALGreat Lakes Food Market Howard Snyder Marketing Manager 2732 Baker Blvd. Eugene OR 97403 USA (503) 555-7555 GROSRGROSELLA-Restaurante Manuel Pereira Owner 5� Ave. Los Palos Grandes Caracas DF 1081 Venezuela (2) 283-2951 (2) 283-3397 HANARHanari Carnes Mario Pontes Accounting Manager Rua do Pa�o, 67 Rio de Janeiro RJ 05454-876 Brazil (21) 555-0091 (21) 555-8765 HILAAHILARION-Abastos Carlos Hern�ndez Sales Representative Carrera 22 con Ave. Carlos Soublette #8-35 San Crist�bal T�chira 5022 Venezuela (5) 555-1340 (5) 555-1948 HUNGCHungry Coyote Import Store Yoshi Latimer Sales Representative City Center Plaza 516 Main St. Elgin OR 97827 USA (503) 555-6874 (503) 555-2376 HUNGOHungry Owl All-Night Grocers Patricia McKenna Sales Associate 8 Johnstown Road Cork Co. Cork Ireland 2967 542 2967 3333 ISLATIsland Trading Helen Bennett Marketing Manager Garden House Crowther Way Cowes Isle of Wight PO31 7PJ UK (198) 555-8888 KOENEK�niglich Essen Philip Cramer Sales Associate Maubelstr. 90 Brandenburg 14776 Germany 0555-09876 LACORLa corne d'abondance Daniel Tonini Sales Representative 67, avenue de l'Europe Versailles 78000 France 30.59.84.10 30.59.85.11 LAMAILa maison d'Asie Annette Roulet Sales Manager 1 rue Alsace-Lorraine Toulouse 31000 France 61.77.61.10 61.77.61.11 LAUGBLaughing Bacchus Wine Cellars Yoshi Tannamuri Marketing Assistant 1900 Oak St. Vancouver BC V3F 2K1 Canada (604) 555-3392 (604) 555-7293 LAZYKLazy K Kountry Store John Steel Marketing Manager 12 Orchestra Terrace Walla Walla WA 99362 USA (509) 555-7969 (509) 555-6221 LEHMSLehmanns Marktstand Renate Messner Sales Representative Magazinweg 7 Frankfurt a.M. 60528 Germany 069-0245984 069-0245874 LETSSLet's Stop N Shop Jaime Yorres Owner 87 Polk St. Suite 5 San Francisco CA 94117 USA (415) 555-5938 LILASLILA-Supermercado Carlos Gonz�lez Accounting Manager Carrera 52 con Ave. Bol�var #65-98 Llano Largo Barquisimeto Lara 3508 Venezuela (9) 331-6954 (9) 331-7256 LINODLINO-Delicateses Felipe Izquierdo Owner Ave. 5 de Mayo Porlamar I. de MargaritaNueva Esparta 4980 Venezuela (8) 34-56-12 (8) 34-93-93 LONEPLonesome Pine Restaurant Fran Wilson Sales Manager 89 Chiaroscuro Rd. Portland OR 97219 USA (503) 555-9573 (503) 555-9646 MAGAAMagazzini Alimentari Riuniti Giovanni Rovelli Marketing Manager Via Ludovico il Moro 22 Bergamo 24100 Italy 035-640230 035-640231 MAISDMaison Dewey Catherine Dewey Sales Agent Rue Joseph-Bens 532 Bruxelles B-1180 Belgium (02) 201 24 67 (02) 201 24 68 MEREPM�re Paillarde Jean Fresni�re Marketing Assistant 43 rue St. Laurent Montr�al Qu�bec H1J 1C3 Canada (514) 555-8054 (514) 555-8055 MORGKMorgenstern Gesundkost Alexander Feuer Marketing Assistant Heerstr. 22 Leipzig 04179 Germany 0342-023176 NORTSNorth/South Simon Crowther Sales Associate South House 300 Queensbridge London SW7 1RZ UK (171) 555-7733 (171) 555-2530 OCEANOc�ano Atl�ntico Ltda. Yvonne Moncada Sales Agent Ing. Gustavo Moncada 8585 Piso 20-A Buenos Aires 1010 Argentina (1) 135-5333 (1) 135-5535 OLDWOOld World Delicatessen Rene Phillips Sales Representative 2743 Bering St. Anchorage AK 99508 USA (907) 555-7584 (907) 555-2880 OTTIKOttilies K�seladen Henriette Pfalzheim Owner Mehrheimerstr. 369 K�ln 50739 Germany 0221-0644327 0221-0765721 PARISParis sp�cialit�s Marie Bertrand Owner 265, boulevard Charonne Paris 75012 France (1) 42.34.22.66 (1) 42.34.22.77 PERICPericles Comidas cl�sicas Guillermo Fern�ndez Sales Representative Calle Dr. Jorge Cash 321 M�xico D.F. 05033 Mexico (5) 552-3745 (5) 545-3745 PICCOPiccolo und mehr Georg Pipps Sales Manager Geislweg 14 Salzburg 5020 Austria 6562-9722 6562-9723 PRINIPrincesa Isabel Vinhos Isabel de Castro Sales Representative Estrada da sa�de n. 58 Lisboa 1756 Portugal (1) 356-5634 QUEDEQue Del�cia Bernardo Batista Accounting Manager Rua da Panificadora, 12 Rio de Janeiro RJ 02389-673 Brazil (21) 555-4252 (21) 555-4545 QUEENQueen Cozinha L�cia Carvalho Marketing Assistant Alameda dos Can�rios, 891 Sao Paulo SP 05487-020 Brazil (11) 555-1189 QUICKQUICK-Stop Horst Kloss Accounting Manager Taucherstra�e 10 Cunewalde 01307 Germany 0372-035188 RANCHRancho grande Sergio Guti�rrez Sales Representative Av. del Libertador 900 Buenos Aires 1010 Argentina (1) 123-5555 (1) 123-5556 RATTCRattlesnake Canyon Grocery Paula Wilson Assistant Sales Representative2817 Milton Dr. Albuquerque NM 87110 USA (505) 555-5939 (505) 555-3620 REGGCReggiani Caseifici Maurizio Moroni Sales Associate Strada Provinciale 124 Reggio Emilia 42100 Italy 0522-556721 0522-556722 RICARRicardo Adocicados Janete Limeira Assistant Sales Agent Av. Copacabana, 267 Rio de Janeiro RJ 02389-890 Brazil (21) 555-3412 RICSURichter Supermarkt Michael Holz Sales Manager Grenzacherweg 237 Gen�ve 1203 Switzerland 0897-034214 ROMEYRomero y tomillo Alejandra Camino Accounting Manager Gran V�a, 1 Madrid 28001 Spain (91) 745 6200 (91) 745 6210 SANTGSant� Gourmet Jonas Bergulfsen Owner Erling Skakkes gate 78 Stavern 4110 Norway 07-98 92 35 07-98 92 47 SAVEASave-a-lot Markets Jose Pavarotti Sales Representative 187 Suffolk Ln. Boise ID 83720 USA (208) 555-8097 SEVESSeven Seas Imports Hari Kumar Sales Manager 90 Wadhurst Rd. London OX15 4NB UK (171) 555-1717 (171) 555-5646 SIMOBSimons bistro Jytte Petersen Owner Vinb�ltet 34 Kobenhavn 1734 Denmark 31 12 34 56 31 13 35 57 SPECDSp�cialit�s du monde Dominique Perrier Marketing Manager 25, rue Lauriston Paris 75016 France (1) 47.55.60.10 (1) 47.55.60.20 SPLIRSplit Rail Beer & Ale Art Braunschweiger Sales Manager P.O. Box 555 Lander WY 82520 USA (307) 555-4680 (307) 555-6525 SUPRDSupr�mes d�lices Pascale Cartrain Accounting Manager Boulevard Tirou, 255 Charleroi B-6000 Belgium (071) 23 67 22 20 (071) 23 67 22 21 THEBIThe Big Cheese Liz Nixon Marketing Manager 89 Jefferson Way Suite 2 Portland OR 97201 USA (503) 555-3612 THECRThe Cracker Box Liu Wong Marketing Assistant 55 Grizzly Peak Rd. Butte MT 59801 USA (406) 555-5834 (406) 555-8083 TOMSPToms Spezialit�ten Karin Josephs Marketing Manager Luisenstr. 48 M�nster 44087 Germany 0251-031259 0251-035695 TORTUTortuga Restaurante Miguel Angel Paolino Owner Avda. Azteca 123 M�xico D.F. 05033 Mexico (5) 555-2933 TRADHTradi��o Hipermercados Anabela Domingues Sales Representative Av. In�s de Castro, 414 Sao Paulo SP 05634-030 Brazil (11) 555-2167 (11) 555-2168 TRAIHTrail's Head Gourmet Provisioners Helvetius Nagy Sales Associate 722 DaVinci Blvd. Kirkland WA 98034 USA (206) 555-8257 (206) 555-2174 VAFFEVaffeljernet Palle Ibsen Sales Manager Smagsloget 45 �rhus 8200 Denmark 86 21 32 43 86 22 33 44 VICTEVictuailles en stock Mary Saveley Sales Agent 2, rue du Commerce Lyon 69004 France 78.32.54.86 78.32.54.87 VINETVins et alcools Chevalier Paul Henriot Accounting Manager 59 rue de l'Abbaye Reims 51100 France 26.47.15.10 26.47.15.11 WANDKDie Wandernde Kuh Rita M�ller Sales Representative Adenauerallee 900 Stuttgart 70563 Germany 0711-020361 0711-035428 WARTHWartian Herkku Pirkko Koskitalo Accounting Manager Torikatu 38 Oulu 90110 Finland 981-443655 981-443655 WELLIWellington Importadora Paula Parente Sales Manager Rua do Mercado, 12 Resende SP 08737-363 Brazil (14) 555-8122 WHITCWhite Clover Markets Karl Jablonski Owner 305 - 14th Ave. S. Suite 3B Seattle WA 98128 USA (206) 555-4112 (206) 555-4115 WILMKWilman Kala Matti Karttunen Owner/Marketing Assistant Keskuskatu 45 Helsinki 21240 Finland 90-224 8858 90-224 8858 WOLZAWolski Zajazd Zbyszek Piestrzeniewicz Owner ul. Filtrowa 68 Warszawa 01-012 Poland (26) 642-7012 (26) 642-7012